package com.ruoyi.system.mapper.HUAWEI;

import com.baomidou.mybatisplus.core.mapper.BaseMapper;
import com.ruoyi.system.domain.HUAWEI.EmsBarcodeMaterial;
import org.apache.ibatis.annotations.Param;
import org.apache.ibatis.annotations.Select;

/**
 * @author GE-LV5
 * @create 2023/4/10 16:56
 */
public interface EmsBarcodeMaterialMapper extends BaseMapper<EmsBarcodeMaterial> {

    @Select("select ISNULL(count(*),0) from EMS_BARCODE_MATERIAL t where t.po=#{taskTon} and t.bar_item_code=#{productCode} and t.item_code=#{childCode}")
    Integer selectByCount(@Param("productCode") String productCode, @Param("taskTon") String taskTon, @Param("childCode") String childCode);
}
